
CREATE DATABASE IF NOT EXISTS suscan default charset utf8 COLLATE utf8_general_ci;
use suscan;


DROP TABLE IF EXISTS `auth`;
CREATE TABLE `auth` (
                        `id` int unsigned NOT NULL AUTO_INCREMENT,
                        `username` varchar(50) DEFAULT '' COMMENT '账号',
                        `password` varchar(50) DEFAULT '' COMMENT '密码',
                        PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of auth
-- ----------------------------
INSERT INTO `auth` VALUES (1, 'admin', 'admin');

-- ----------------------------
-- Table structure for assets
-- ----------------------------
DROP TABLE IF EXISTS `assets`;
CREATE TABLE `assets` (
                          `id` int NOT NULL AUTO_INCREMENT,
                          `name` varchar(255) DEFAULT NULL,
                          `target` varchar(255) DEFAULT NULL,
                          `created_time` varchar(255) DEFAULT NULL,
                          `updated_time` varchar(255) DEFAULT NULL,
                          PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of assets
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for url
-- ----------------------------
DROP TABLE IF EXISTS `url`;
CREATE TABLE `url` (
                       `id` int NOT NULL AUTO_INCREMENT,
                       `url` varchar(255) DEFAULT NULL,
                       `ip` varchar(255) DEFAULT NULL,
                       `created_time` varchar(255) DEFAULT NULL,
                       `updated_time` varchar(255) DEFAULT NULL,
                       PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


